Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DBA_ADVISOR_COMMANDS

`DBA_ADVISOR_COMMANDS` displays information about the commands used by all advisors in the database for specifying recommendation actions. In addition to the set of commands in the `COMMAND` column of `V$SESSION`, the following additional commands are defined:

- `RUN ADVISOR`

- `CHECK EXECUTION PLAN`

- `ALTER PARAMETER`

- `ENABLE TRACE`

Column | Datatype | NULL | Description
--- | --- | --- | ---
`COMMAND_ID` | `NUMBER` |  | Identifier of the command
`COMMAND_NAME` | `VARCHAR2(64)` |  | Name of the command